﻿using SIIE_ERP.Codigo;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SIIE_ERP.BaseDatos.Inventarios.Catalogos
{
    public class dbo_Cat_TipoArticulo
    {
        #region SELECT

        public DataTable Get_Tipos_Articulo()
        {
            string Query = @"SELECT 
                                A1.*
                            FROM dbo_Cat_Tipo_Articulo AS A1";

            return SrvDB.ExecuteQuery_Get(Query);
        }

        public string Get_Id_Kit()
        {
            string Query = @"SELECT 
                                A1.*
                            FROM dbo_Cat_Tipo_Articulo AS A1 WHERE A1.Nombre = 'Kit'";

            return SrvDB.ExecuteQuery_Get(Query).Rows[0]["Id_Tipo_Articulo"].ToString();
        }

        public string Get_Id_Articulo()
        {
            string Query = @"SELECT 
                                A1.*
                            FROM dbo_Cat_Tipo_Articulo AS A1 WHERE A1.Nombre = 'Producto'";
            return SrvDB.ExecuteQuery_Get(Query).Rows[0]["Id_Tipo_Articulo"].ToString();
        }

        #endregion
    }
}
